[dbo].[asi_UpdateDesignRuleSource]

SQLServer > iMIS1521GA > Stored Procedures > dbo.asi_UpdateDesignRuleSource

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@objectName	nvarchar(100)	200
@source	ntext	16

SQL Script

CREATE PROCEDURE [dbo].[asi_UpdateDesignRuleSource]

@objectName nvarchar(100),
@source ntext

AS

IF EXISTS(SELECT 1 FROM RuleSourceDesign WHERE RuleName = @objectName)
    BEGIN
        UPDATE RuleSourceDesign SET RuleCode = @source WHERE RuleName = @objectName
    END
ELSE
    BEGIN
        INSERT RuleSourceDesign (RuleName, RuleCode) VALUES (@objectName, @source)
    END

GO

Uses

[dbo].[RuleSourceDesign]
dbo